package com.sdstc.modules.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.base.BaseDao;
import com.sdstc.modules.eneity.PersonEntity;
import com.sdstc.modules.vo.OrgPeopleDetailVo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author ：wk
 * @date ：Created in 2022/10/23 13:23
 */
public interface PersonDao extends BaseDao<PersonEntity> {
    @Select("select id,`name`,police_no,post_big_cate_code,job_title,identity_no,contact_phone,org_id from person where org_id = #{id} and (status=#{ok} or status=#{high})")
    List<OrgPeopleDetailVo> queryOrgPeople(@Param("id") String id, @Param("ok") String ok, @Param("high") String high);

}
